package com.whmskj.xjlhbc.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.whmskj.xjlhbc.domain.StatisticsOnTheDailyProductionOf;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

@Mapper
public interface StatisticsOnTheDailyProductionOfMapper extends BaseMapper<StatisticsOnTheDailyProductionOf> {

    @Select("select * from tj04dWeavingWorkshopDaytodayProd where statisticsDate between #{begin} and #{end } order by statisticsDate desc")
    List<Map<String,Object>> selectBzdbList(@Param("begin") String begin, @Param("end") String end);

    //整经月产量汇总
    @Select("select * from bctj12d0TotalMonthlyProduction where year=#{year} and month=#{month}")
    Map<String,Object> selectZjClMonth(@Param("year") int year,@Param("month") int month);

    //整经日产量
    @Select("select * from bctj12TotalDailyProduction where statisticsDate between #{begin} and #{end } order by statisticsDate desc")
    List<Map<String,Object>> selectZjClList(@Param("begin") String begin, @Param("end") String end);

    //浆纱月产量汇总
    @Select("select * from totalProductionOfBctj13Sar02cophag where year=#{year} and month=#{month}")
    Map<String,Object> selectJsClMonth(@Param("year") int year,@Param("month") int month);

    //浆纱日产量
    @Select("select * from bctj13AnnualTotalProductionOfSar where statisticsDate between #{begin} and #{end } order by statisticsDate desc")
    List<Map<String,Object>> selectJsClList(@Param("begin") String begin, @Param("end") String end);

}
